<?php

// 4/25/2010: immanuel192 write this action to return bible translation books

if (!defined('EXPONENT')) exit('');

global $db;
$data=$db->selectObjects("bible_vi_bdm","(bibletext LIKE '%  %') OR (bibletext LIKE '%%')");
foreach ($data as $k=>$v)
{
	$st=$v->bibletext;
	$st=str_replace("","",$st);
	$st=str_replace("  "," ",$st); $st=str_replace("  "," ",$st);
	$sql="UPDATE {$db->prefix}bible_vi_bdm SET bibletext='{$st}' WHERE (book={$v->book}) AND (chapter = {$v->chapter}) AND (verse = {$v->verse})";
	$db->sql($sql);
	echo " (book={$v->book}) AND (chapter = {$v->chapter}) AND (verse = {$v->verse})<br>";
}
die();
?>
